Thread: will VLookup peek over it's shoulder?

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
spam@uce.gov
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
> spam@uce.gov
> 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
> spam@uce.gov
> 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
| spam@uce.gov
| Thanks, robots.
|
|
|
|
|