Hi,
Can anyone please advise me on how to amend the syntax of my formula to check first to see if there is a value in cell O2 i.e. not empty/blank
If the cell O2 is empty/blank then perform the Vlookup otherwise display the cell as empty/blank.
=IFERROR(VLOOKUP(N2,'SR Cross Ref '!B:L,2,FALSE),"")
Many thanks in advance
Regards
Rob
Rob
=IF(O2="",IFERROR(VLOOKUP(N2,'SR Cross Ref '!B:L,2,FALSE),""),"")
OR
=IF(ISBLANK(O2),IFERROR(VLOOKUP(N2,'SR Cross Ref '!B:L,2,FALSE),""),"")
=IF(O2<>"", IFERROR(VLOOKUP(N2,'SR Cross Ref '!B:L,2,FALSE),""),"")
or
=IF(isblank(O2), IFERROR(VLOOKUP(N2,'SR Cross Ref '!B:L,2,FALSE),""),"")
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
PFDave & etaf,
Excellent !! many thanks for your assistance it is very much appreciated
Regards
Rob
No worries Rob, thanks for the rep
you are welcome , thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks