Compare a A2 (Sheet1) cell with a column A (sheet2) if A2(Sh

October 6, 2012 at 13:42:07
Specs: Windows 7
I need to check A1(sheet 1) with the column A (sheet2 )if the value matches in any of the cell of coulmn A(sheet2) i want the data from correspondence cell of Column C (sheet2)
Means if A1(sheet1) value matches with A15(Sheet2) value then i want the data existing in C15(sheet2)

See More: Compare a A2 (Sheet1) cell with a column A (sheet2) if A2(Sh

Report •

October 6, 2012 at 14:02:53
Sounds exactly like what VLOOKUP is used for.

Read the Excel Help files on VLOOKUP, or do a Google search on it.

VLOOKUP is a very powerful function so you should get familiar with it.

If you have any problem getting it to work, come on back with what you've tried and we'll see if we can help out.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question