I'm trying to compare some parts using vlookup. If the part numbers are the same I need to pull in column 5, however if column 5 is blank I need to pull in column 10.
I'm assuming I need an IF statement in the col_index argument, but can't seem to construct it successfully.
=VLOOKUP(A2, G2:R1500,???,FALSE)
Thanks for any input.
Try:
=IF(VLOOKUP(A2,G2:R1500,5,FALSE)="",VLOOKUP(A2,G2:R1500,10,FALSE),VLOOKUP(A2,G2:R1500,5,FALSE))
OR:
=INDEX(G2:R1500,MATCH(A2,G2:G1500,0),IF(INDEX(G2:R1500,MATCH(A2,G2:G1500,0),5)="",10,5))
Last edited by GeneralDisarray; 07-06-2016 at 03:44 PM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks