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