Using two Vlookups to check if Ref exists

[howard]

I have Refences in Col G

I have tried to set up a formula below to look up the reference in Col G on workbook Sales BR1.xlsm on sheet Data Import in Col D as well as on Sales BR2.xlsm]Data Import’ and if it exists to return the ref number, otherwise return a blank

It would be appreciated if someone could amend my formula

 =IFERROR(VLOOKUP(G2,'[Sales BR1.xlsm]Data Import’!$D:$D,1,FALSE),VLOOKUP(G2, Sales BR2.xlsm]Data Import’!$D:$D,1,FALSE),””)

 

[kieran]

Do you need to test for an error in the 2nd VLOOKUP?
Something like... (untested)

=IFERROR(VLOOKUP(G2,'[Sales BR1.xlsm]Data Import’!$D:$D,1,FALSE),IFERROR(VLOOKUP(G2, Sales BR2.xlsm]Data Import’!$D:$D,1,FALSE),""),””)

 

[RoryA]

You're missing another IFERROR and a square bracket.

=IFERROR(IFERROR(VLOOKUP(G2,'[Sales BR1.xlsm]Data Import'!$D:$D,1,FALSE),VLOOKUP(G2, '[Sales BR2.xlsm]Data Import'!$D:$D,1,FALSE)),"")

 

[howard]

Hi Kieran & Rory


Thanks for the help, much appreciated