This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 57.00000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
I am looking to have a VLOOKUP that does something like the following:
IF this vlookup returns a value, then do the vlookup however if the value or this vlookup is blank then go on to another IF vlookup statement (I need to complete 5 in total in this formula). I have tried the formula below but I am missing something.
=IF(VLOOKUP(F16,'HELPER FOR ALL IN ONE'!A2:O1000,2,0)<>"",VLOOKUP(F16,'HELPER FOR ALL IN ONE'!A2:O1000,2,0),IF(VLOOKUP(F16,'HELPER FOR ALL IN ONE'!A1002:O2000,2,0)<>"",VLOOKUP(F16,'HELPER FOR ALL IN ONE'!A1002:O2000,2,0),IF(VLOOKUP(F16,'HELPER FOR ALL IN ONE'!A2002:O3000,2,0)<>"",VLOOKUP(F16,'HELPER FOR ALL IN ONE'!A2002:O3000,2,0),IF(VLOOKUP(F16,'HELPER FOR ALL IN ONE'!A3002:O4000,2,0)<>"",VLOOKUP(F16,'HELPER FOR ALL IN ONE'!A3002:O4000,2,0),IF(VLOOKUP(F16,'HELPER FOR ALL IN ONE'!A4002:O5000,2,0)<>"",VLOOKUP(F16,'HELPER FOR ALL IN ONE'!A4002:O5000,2,0))))))
I appreciate any help anyone can provide and I thank you in advance!
Hi @Dustin Shepard ,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 25%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Hi
Without your data it's nigh on impossible to give you an answer. Can you attach your workbook please.
Phil
Hi @Dustin Shepard ,
This formula is worked fine:
I suggest you provide your sample about this problem, so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.
Try to check if there are duplicate data in HELPER FOR ALL IN ONE Worksheet Column A for F16.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.