Excel 2003 - VLOOKUP with IF?

[db1966]

I'm creating a workbook that autofills data from various files saved on a shared drive. The data changes on a monthly basis to provide report information for various parties. I'm using a main sheet to hold the data, which then transfers to a Powerpoint template. The problem I'm finding is when the refreshed data has no records. The formula I'm using to retrieve the data is:-

=VLOOKUP(A1,Data1!$A$1:$D$7,4,TRUE)

Works fine when there is data there to retrieve, but if it's empty (other than the headings) or the particular contractor isn't included for any particular month, the results are not exactly what I'm looking for! Is it possible to use an IF statement first to establish whether the fields are empty and populate the fields accordingly, and then follow that with the VLOOKUP formula?

I've attached a mockup of what I'm trying to do which will hopefully help.ForumDataSheet.xls

As always, any help/advice appreciated.

[Kyle123]

try this

=IF(ISERROR(VLOOKUP(B1,Data1!$A$1:$D$7,4,FALSE)),"",VLOOKUP(B1,Data1!$A$1:$D$7,4,FALSE))  

[db1966]

Perfect! Thanks, hadn't even considered using ISERROR, much appreciated

[ConneXionLost]

How about:

Please Login or Register  to view this content.

Cheers,

[Kyle123]

Thats a good idea never thought of that!