MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Comparing two spreadsheets and returning a value


Posted by Dave M. on June 27, 2001 7:14 AM

Hi,

I have two spreadsheets of data which have po's on them. I am trying to do a lookup where I can match the po's and return a value into the first spreadsheet. for example sheet 1 has

PO, date, cost, office

sheet 2 has
po, cost, office, country

I want to match the POs and return the country to the first spreadsheet. Any ideas???


Posted by Russell on June 27, 2001 7:19 AM

VLOOKUP

Use VLOOKUP. So lookup the PO value in your second sheet and return the 4th column. Email me a sample if, after looking up VLOOLUP in help, you still don't understand...

Russell