[RESOLVED] VLOOKUP Help?

[frankwhite]

Hi guys

I was hoping someone could offer me some help please, basically I have data in column A and some data in column B and C (data in column B and C are togather). I need help with VLookup which will look for each value in column A and IF it matches anything in column B (from cell B1 to B2000) then i want to display it in E.

Not only this but I want the data from column C (which is linked to the data in column B) i want to display in column F.

So basically after running the Vlookup I want to see which data matches from column a and column b and I want to display this in column e.

if you need any more help or want me to explain anything else then let me know. thanks guys

**Edit is this possible to do in VBA? If VBA is an easier method then I dont mind as I can get the answer.

[elleg]

If I understand you correctly, these formulas should work for you:

In cell E1 put:
=IF(ISNA(VLOOKUP(A1,$B:$B,1,FALSE)),"",VLOOKUP(A1,$B:$B,1,FALSE))

In cell F1 put:
=IF(ISNA(VLOOKUP(E1,$B:$C,2,FALSE)),"",VLOOKUP(E1,$B:$C,2,FALSE))

Drag these two formulas down for however many rows you need. If you have headers (etc.) on these columns, then of course you will want to change the cell to lookup to match the row you start in (e.g. E1 becomes E2, F1 becomes F2, etc.)

These formulas will display nothing (empty cell) if no match is found, but will display the matched value if something is found. Does that make sense?

[frankwhite]

Thank you sooo much, you dont know how much i appreciate it!

rated