Vlookup when column varies

1. Vlookup when column varies

Hi all!

I want to search for a particular number in a table. The first column is a unique letter, and in the row containing that letter is a series of numbers.

What formula can i use to find a particular number in this table when it could be in any row, and return the letter in the first column?

Screen Shot 2019-12-27 at 16.17.15.png

Thanks for the help!

2. Re: Vlookup when column varies

Welcome to the forum.

How to attach your workbook: instructions in the banner at the top of the page.

3. Re: Vlookup when column varies

Hi. Adapt this to the range of cells in yoru real sheet:

=INDEX(\$B:\$B,MAX(INDEX((\$C\$4:\$L\$18=\$O4)*ROW(\$C\$4:\$L\$18),0)))

4. Re: Vlookup when column varies

Here is another one

Formula:
`Please Login or Register  to view this content.`

 v B C D E F G 1 2 Enter Number 33 3 Letter is: D 4 5 C 85 51 17 6 S 34 26 13 22 7 P 55 39 11 8 D 65 33 7 9 B 35 21 14

There are currently 1 users browsing this thread. (0 members and 1 guests)