Forum Discussion
double hlookup in one formula
How can I combine two Hlookups in one formula Worksheet One is my summary sheet Worksheet Two contains UK Ltd data Worksheet Three contains USA Inc data Worksheet one the Summary sheet, cur...
You don't need second "=", something like
=IFERROR(HLOOKUP(A4,'2018 Jan - June LTD'!$J$5:$BB$8,4,FALSE)+HLOOKUP(A4,'2018 Jan - June INC'!$J$5:$BB$8,4,FALSE),"")
thankyou for your reply.
This seems to only work if there is relevant data in both worksheet, if not it returns a blank, when infact it should return the total of the one worksheet.
Eg Worksheet with relevant data £100.00 + Worksheet without relevant data £0.00 = £100
I see. When wrap by IFERROR each part
=IFERROR(HLOOKUP(A4,'2018 Jan - June LTD'!$J$5:$BB$8,4,FALSE),0)+IFERROR(HLOOKUP(A4,'2018 Jan - June INC'!$J$5:$BB$8,4,FALSE),0)
That has worked thank you.