If data is in A1:D10 and lookup value is in K1 say, try:

=INDEX(A$1:A$10,MIN(IF(A$1:H$10=K1,ROW(A$1:H$10))) )

executed with ctrl+shift+enter as it's an array formula.


On 15 Mar, 23:08, FredL wrote:
So I have a tab that contains the following data:
Project Order1 Order2 Order3 etc
ABC 123 456 789
DEF 654 951 159

Basically, I want to do a search (similar to ctrl - H) on the tab and look
for Order 159. The main information I want is the Project name. I've got
thousands of line, and hundred of Orders to look up; orders go all the way
to
column IV on a few of them. So I need either a formula (similar to vlookup
or search) or a macro that can look up a cell, search the other tab, and
return either a cell location or, better yet, the project.

Is this possible? Thanks.