Vlookup and Hlookup with an IF condition

G

g10drac

Joined
Oct 13, 2011
Messages
1
Reaction score
0
Hi,

I am trying to look up values using if condition combined with vlookup and hlookup. The values are in a separate workbook/worksheets to the target workbook/worksheet.

Below is the formula which I have at the moment. But I get 'N/A' error.

=IF(HLOOKUP($B2,'C:\ABC\[Workbook1.xlsm]Payment.D1'!$B$2:$Z$100,10,FALSE)="Worker",
VLOOKUP($A2,'C:\ABC\[Workbook1.xlsm]WorkerNames'!$B$2:$Z$100,5,FALSE),IF(HLOOKUP($B2,'C:\ABC\[Workbook1.xlsm]Payment.D1'!$B$2:$Z$100,10,FALSE)="Employer",HLOOKUP($B2,'C:\ABC\[Workbook1.xlsm]Payment.D1'!$B$2:$Z$100,11,FALSE),IF(HLOOKUP($B2,'C:\ABC\[Workbook1.xlsm]Payment.D1'!$B$2:$Z$100,10,FALSE)="Provider",HLOOKUP($B2,'C:\ABC\[Workbook1.xlsm]Payment.D1'!$B$2:$Z$100,11,FALSE))))

--- Jet :wall:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display data using hlookup, index-match and offset 1
Extremely slow calculation of formulas 4
Question regarding HLookup (unique values) 7
Lookup row and columbn using text for both 4
Odd Problem with HLOOKUP -- Any change breaks it 5
Help with Nested IF Statements 4
Getting the next higer value with Vlookup - True 5
Vlookup and Hlookup Combine? 1

Top