Hi,
I have the following data available on my DATA spreadsheet:
Arrival Date
Nationality
Room Number
On my Feedback Sheet I have the following data:
Arrival Date
Room Number
How can I lookup the Nationality on my Feedback sheet based on the arrival date and room number? When using VLOOKUP() I can only enter one value to match, merging the date and room number together doesnt work...
Any suggestions?
Thanks,
A2k
Bookmarks