You can use =index(match())

See Debra Dalgleish's site for lots of instructions:
http://www.contextures.com/xlFunctions03.html

Rodney wrote:

Say I have 8 columns, A thru H
the lookup table is column C
Can Vlookup find the match in C3501, and report the
resultant number residing in B3501?

...or do I cut and paste column c to column a?
which would be a pain in the botty.

Thanks

--
rodney at touch88.com.au

Send spam to the FTC at

Thanks, robots.

--

Dave Peterson