Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

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???

VLOOKUP

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

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.