need a if formula nest with vlookup

what are you VLOOKUP in Column A. these are not Date values? then you can try this

=IFERROR(VLOOKUP(A1,Your Range,Column Number,False),"")

Select allOpen in new window

.which returns to blank if there is no match up.


Thanks

or you can try this which is more specific to your question.

=IF(CELL("Format",A1)="D1","",VLOOKUP(A1, Your Range, Column Number, False)

Select allOpen in new window

Thanks

Hi Experts

quick questions why d1...so if a1 has a date the b1 is blank?

=IF(CELL("Format",A1)="D1","","Y")

Select allOpen in new window

if A1 = date returns to D1else "Y"

quick questions why d1

for date format value is D1.

so if a1 has a date the b1 is blank?

Yes

Hi itjockey


=IF(CELL("Format",A1)="D1","",VLOOKUP(A1, Your Range, Column Number, False)

I am using the above and surely it should be if a1 has a date then return back in cell b1..if a1 has not date the apply the vlookup formula. .

or provide your VLOOKUP Formula only I will merge & revert you back.

Vlookup(a5,'app p'! $b$26:$q$1200,16,0)

=IF(CELL("Format",A5)="D1","",VLOOKUP(A5,'app p'! $B$26:$Q$1200,16,False)

Select allOpen in new window

=IF(CELL("Format",A1)="D1","",VLOOKUP(A5,'app p'! $B$26:$Q$1200,16,False)

Select allOpen in new window

bit confused Cell A1 or A5 so added both .


Thanks

Sorry to  be a pain...

can you attach a workbook...still cannot get this to work.

In stead  of mine why don't you upload yours as I don't have sheet name "app p" I just write formula.

for understanding see attached.

Thanks
Book2.xlsx

Ok thanks...

how would you amend if a1 is blank and b1 is blank then vlookup..into the above if formula.

provide your sample workbook.

Thanks