Hi guys, i'm trying to get some results with =HLOOKUP(H6;Sheet1!$D$5:$AB$31;27;FALSE) but in the first row works fine. When i paste the formula in the next rows i get #N/A. With =IFERROR(HLOOKUP(H6;Sheet1!$D$5:$AB$31;27;FALSE);"") just hide the #N/A. Can you tell me what im doing wrong and i can get the result only in the first row? Thanks in advance.
It seems that H6 exists in that range, but are you sure that H7 is there too? If you think it does, check for leading/trailing spaces
Hard to say without seeing a sample workbook, can you upload a sample?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks FDibbins for your interest, actually right now no, but i insert =IFERROR(INDEX(Sheet1!$D$31:$AB$31;MATCH($F6;Sheet1!$D$4:$AB$4;0));"") and i' ve got that i want properly
Great stuff. Index/Match is often a better option to use, instead of v/hlookup()
With the formula in Post #3 your are looking at the range D4:AB4, but the table in your HLOOKUP formula in your first post was looking at row 5.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks