How do I use Lookup to return a row of values eg. 6 cells

B

Bemused

I am trying to write a lookup command that returns a row of outputs rather
than the output of one cell. Having some difficulty would appreciate any
tips availble.
 
B

Biff

Hi!

You need a separate formula for each value you want to return. (or you could
use an array Offset)

If the 6 values you need are in consecutive cells in the lookup table then
you use something like this and just drag copy across:

=VLOOKUP(4,$A1:$G5,COLUMN(B:B),0)

Biff
 
Top