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.

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

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

"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.

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
|
| Thanks, robots.
|
|
|
|
|