CarrieWarrie
New Member
 Joined
 Mar 8, 2013
 Messages
 23
 Office Version

 2019
 2013
 Platform

 Windows
Hi guys,
Wondering if anybody can help me  I have been trying to figure out this formula for 2 days now, with no luck
I'm trying to figure out how to use Excel to find and return a value. It's quite difficult to explain (sorry, my brain is exhausted after trying to figure this out), so I'll try to use an example:
I have one spreadsheet tab (Inspector) that is all addresses for hotels  Postal Number, Street, Town, Postcode
I have another tab on the same spreadsheet (Sheet1) that is general addresses for every property in the area  Postal Number, Street, Town, Postcode and a unique identifier.
How on earth can I insert a function into Inspector that will look up Sheet2 based upon matching Postal Numbers and Postcode, and return the unique identifier?
I basically want the function to use the Postal Number and Postcode of row 1 in Inspector to find a row in Sheet1 that matches these two criteria, and to return the value of the unique identifier belonging to that row. I then want to apply this to every row in Inspector.
I apologise for the convoluted and poor explanation  I have tried VLOOKUP, INDEX & MATCH, INDEX MATCH MATCH, HLOOKUP... nothing seems to work
I've included 2 screen snips of the 2 tabs and the data (couldn't see a way of uploading the spreadsheet, apologies).
Any help at all would be amazing.
Thank you so much <3
Wondering if anybody can help me  I have been trying to figure out this formula for 2 days now, with no luck
I'm trying to figure out how to use Excel to find and return a value. It's quite difficult to explain (sorry, my brain is exhausted after trying to figure this out), so I'll try to use an example:
I have one spreadsheet tab (Inspector) that is all addresses for hotels  Postal Number, Street, Town, Postcode
I have another tab on the same spreadsheet (Sheet1) that is general addresses for every property in the area  Postal Number, Street, Town, Postcode and a unique identifier.
How on earth can I insert a function into Inspector that will look up Sheet2 based upon matching Postal Numbers and Postcode, and return the unique identifier?
I basically want the function to use the Postal Number and Postcode of row 1 in Inspector to find a row in Sheet1 that matches these two criteria, and to return the value of the unique identifier belonging to that row. I then want to apply this to every row in Inspector.
I apologise for the convoluted and poor explanation  I have tried VLOOKUP, INDEX & MATCH, INDEX MATCH MATCH, HLOOKUP... nothing seems to work
I've included 2 screen snips of the 2 tabs and the data (couldn't see a way of uploading the spreadsheet, apologies).
Any help at all would be amazing.
Thank you so much <3