Sign in to join the conversation:
Hi Team, In regards to the LOOKUP() function can the lookup_value be a cell reference instead of a "text" search?
Hi Mark,
It sure can, an example as follows from testing this on my sheet:
=LOOKUP(Lookup6, Items1:[Part Number]4, 2)
When entering a value in the "Lookup6" cell, it returns the corresponding value from my lookup table.
Awesome, thanks Shaine!
