Please help me with a VLOOKUP

leigh_ashlin

Board Regular
Joined
Feb 9, 2005
Messages
74
Hi there,

I have 2 columns of data:

Worksheet 1 Column A
Worksheet 2 Column C

I need to find which values in Worksheet 2 Column C, match the values in Worksheet 1 Column A.

I really, really don't know how to do this and have fiddled around with VLOOKUP for a while without success.

Can somebody please help me?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Artorius

Board Regular
Joined
Apr 18, 2006
Messages
176
Firstly, name the range in Column A in Worksheet 1.

To do this, highlight column A in Worksheet 1, click on Insert, then on Name, then type in a name ... lets call it TEST.

In Column D in Worksheet 2, type in the following formula, assuming the first data in Column C that you want to look up is in cell C2:-

=VLOOKUP(C2,TEST,1,FALSE)

If excel finds a match in Column C2 of Worksheet2 in Column A of Worksheet1 ... it will return the value in Column A of Worksheet 1 in cell D2. If there is no match, you will get a #N/A.

If you do not want the #N/A's on your worksheet .... change the formula to the following:-

=IF(ISNA(VLOOKUP(C2,TEST,1,FALSE)),"",VLOOKUP(C2,TEST,1,FALSE))

Hope this helps.
 

Forum statistics

Threads
1,136,993
Messages
5,679,023
Members
419,800
Latest member
spvsr999

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top