Previous Topic Next Topic

Vlook up

Closed
Ctharanath - Mar 8, 2010 at 06:49 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 8, 2010 at 08:42 AM
Hello,

I need a help on Vloop up feature.

My requirement is

in Sheet1 i have A,B,C columns and in sheet2 i have A B column and C should automatically update.

Combination of A and B column is coumn C. So i need a vloop up formula, which should compare the column A and B in sheet 1 with the column A and B in the Sheet 2 and automatically update the value in column C in sheet 2 (as per sheet1).

I hope you understood the question.

Please help me its urgent.

Thanks in advance

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 8, 2010 at 08:42 AM
Most easy way would be if you could add a new column in Sheet1 before column C

lets say you insert this new column in A

then in A1 write

=B1 & "|" & C1 and drag it to last row

then on sheet 2 for look up you can use

=Vlookup(A1 & "|" & B1, sheet1!A:D, 4, false)
0