Excel lookup functions?

[pmkieffe]

Hi,

Thanks for any help.

I am familiar with Excel lookup functions, but I am looking for something more than VLOOKUP and LOOKUP.

Lets say I have column A and B on one tab. I have column C and D on another tab.

A B C D

I would like to search column A for any matches with column C. If there is a match, I would like to display the value in column D in column B.

I may have explained too much confusion. I dont want to look for a specific value like the LOOKUP functions do, I want to look for ANY matches between the two columns A and C. Any help would be appreciated.

Thanks,
pmkieffe

 

[SkipVought]

Hi,

Why will VLOOKUP not work?

Please post some sample data that demonstrates your requirement.

Skip,
[sub]
[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion! [/sub]

 

[pmkieffe]

Thanks for the reply. The objective changed on me. VLOOKUP is all I need now.

Thanks,
pmkieffe

 

[firefytr]

Check out the INDEX/MATCH combo as well for a dynamic range based on a row find.

-----------
Regards,
Zack Barresse