If Then Statement help

New Contributor

I have 8 pages of vlookups and I need to get all of the information on the same page. I am trying to figure out how to say...if column A in Excel Sheet 1 matches Column A in Excel Sheet 2, then enter the corresponding info from Column B in Excel Sheet 2 in to Column C in Excel Sheet 1...I can only seem to figure out true or false if then results. Would really love some help.

1 Reply
VLOOKUP(), INDEX/MATCH(), XLOOKUP(), FILTER() may work for you. Put few sample data (you can attach a sample file) and show us your desired result. Also, which version of Excel do you use? Excel-2013, 2016, 2019, 2021 or Excel-365?