will VLookup peek over it's shoulder?

[Rodney]

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
[email protected]
Thanks, robots.

 

[Dave Peterson]

You can use =index(match())

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

 

[JMB]

No. VLOOKUP does not look left. Per Dave's suggestion, Index/Match can do
the trick.

 

[Rodney]

Thank you very much both Dave and JMB.
appreciated.




| 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
| [email protected]
| Thanks, robots.
|
|
|
|
|