I All , i would need help in use same effect formula used in Google spreadsheet into O365 web collaboration excel.
Below the current working Google formula :
=IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(VLOOKUP(J4,Italy!A:G,7,FALSE),VLOOKUP(J4,Italy!B:G,6,FALSE)),VLOOKUP(J4,Italy!C:G,5,FALSE)),VLOOKUP(J4'Part No./Drops'!A:B,2,FALSE)),"no match"))
Basically i have an excel with a tab named Italy where i have db of all hardware(asset tag column A , IMEI column B , serial number column C.
There is also another tab named "Part No./Drops" where there is db of non-asset tagged items (e.g. consumables).
Then there is a tab(this is the one which i need the formula for) where i need to track in/out flow which have auto-fill function based on asset tag/IMEI/Serial number/part number.
I need a single formula into "Item auto-fill" column into in/out flow tab which lookup into Italy tab for Asset tag value (J4,Italy!A:G,7,FALSE) , if error/NA look for IMEI (J4,Italy!B:G,6,FALSE)) , if error/NA look for serial number (J4,Italy!C:G,5,FALSE)) , if error/NA look for part number into Part No./Drops tab (J4'Part No./Drops'!A:B,2,FALSE)) and finally if error/NA for all the vlookup return "no match".
Briefly i would need a single formula which lookup for a value into different columns on Italy tab and into Part No./Drops tab at same time.
I hope i have explained clearly my need and available to provide further.
Please find attached a screenshot of in subject excel spreadsheet.
Thanks
Anto
Below the current working Google formula :
=IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(VLOOKUP(J4,Italy!A:G,7,FALSE),VLOOKUP(J4,Italy!B:G,6,FALSE)),VLOOKUP(J4,Italy!C:G,5,FALSE)),VLOOKUP(J4'Part No./Drops'!A:B,2,FALSE)),"no match"))
Basically i have an excel with a tab named Italy where i have db of all hardware(asset tag column A , IMEI column B , serial number column C.
There is also another tab named "Part No./Drops" where there is db of non-asset tagged items (e.g. consumables).
Then there is a tab(this is the one which i need the formula for) where i need to track in/out flow which have auto-fill function based on asset tag/IMEI/Serial number/part number.
I need a single formula into "Item auto-fill" column into in/out flow tab which lookup into Italy tab for Asset tag value (J4,Italy!A:G,7,FALSE) , if error/NA look for IMEI (J4,Italy!B:G,6,FALSE)) , if error/NA look for serial number (J4,Italy!C:G,5,FALSE)) , if error/NA look for part number into Part No./Drops tab (J4'Part No./Drops'!A:B,2,FALSE)) and finally if error/NA for all the vlookup return "no match".
Briefly i would need a single formula which lookup for a value into different columns on Italy tab and into Part No./Drops tab at same time.
I hope i have explained clearly my need and available to provide further.
Please find attached a screenshot of in subject excel spreadsheet.
Thanks
Anto