Forum Discussion
lookup help
Kieren20101
I have attached a sample file based on the screenshots you provided.
Borefield sheet:Asset Condition sheet:
the formula used in Asset Condition sheet to lookup your asset/generator to Borefield sheet in column B and I.
=IFERROR(IFERROR(INDEX(Borefield!$A$4:$A$30,MATCH($A2,Borefield!$B$4:$B$30,0)),INDEX(Borefield!$I$4:$I$30,MATCH($A2,Borefield!$J$4:$J$30,0))),"Not Found")
Rodrigo_ ,
You're an absolute legend. It wasn't working for me when i did the ctrl+shift+enter but that was just because of how i had the program opened. I've now managed to get it to work but it seems the =B4&J4 is what is stuffing me up now as they're joined together on the Q column.
Kieren20101
Try this formula:
=IFERROR(INDEX(Borefield!A:A, MATCH(A2, Borefield!Q:Q, 0)), INDEX(Borefield!I:I, MATCH(A2, Borefield!Q:Q, 0)))No need to press CTRL + SHIFT + ENTER.
Just press Enter key only
Kieren20101
I have attached a sample file based on the screenshots you provided.
Borefield sheet:Asset Condition sheet:
the formula used in Asset Condition sheet to lookup your asset/generator to Borefield sheet in column B and I.
=IFERROR(IFERROR(INDEX(Borefield!$A$4:$A$30,MATCH($A2,Borefield!$B$4:$B$30,0)),INDEX(Borefield!$I$4:$I$30,MATCH($A2,Borefield!$J$4:$J$30,0))),"Not Found")- could you upload your file here? or thru drive. without sensitive data
- The same results. Am i able to set it so in Q4 its =B4 and R4 is =J4 and I'm able to to get A2 to look in Borefields Q:Q and R:R?