I am using this foumula to search A36:D59 for the value = to J105 then display value of cell 3 column's across
=IFERROR(VLOOKUP(J105,A36:D59,4,FALSE),"0")
How do I change this so that instead it displays the value of the cell one row down ?
I am using this foumula to search A36:D59 for the value = to J105 then display value of cell 3 column's across
=IFERROR(VLOOKUP(J105,A36:D59,4,FALSE),"0")
How do I change this so that instead it displays the value of the cell one row down ?
Try
=IFERROR(MATCH(VLOOKUP(J105,A36:D59,4,FALSE),A36:A59,0)+1,0)
This assumes there is only one occurrence of the VLOOKUP result in column A
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
would it work if the VLOOKUP result was
1/ a word ?
2/ not in column A ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks