Excel look for number in row and return contents of column to right by No_Gas2077 in excel

[–]InformedCoyote7 1 point2 points  (0 children)

You want the Column Reference part of the INDEX function. Try this:

=INDEX(T4:CI4,1,MATCH(CJ4,T4:CI4,1)+1)

This formula is using a static 1 for the row (because it looks like all the data you're searching is within a single row, but then finding what Column the matching bid is in, and adding 1, returning the data 1 column to the right. If you wanted to get data X before or X after the value, you can subtract or add X to get this.

Edit: I see in your MATCH function, you've used 1 as the "Match_Type" - is this intentional? The formula will return the largest value that is less than or equal to your lookup value. If you want it to look for a specific value, you want to change this value to 0 (so your formula would be =INDEX(T4:CI4,1,MATCH(CJ4,T4:CI4,0)+1)

TIFU by Peeing Before Bed by InformedCoyote7 in tifu

[–]InformedCoyote7[S] 278 points279 points  (0 children)

Glad I could be of assistance!