VLOOKUP formula with "#VALUE"

[Guest]

I have this formula below in E8:
=IF(ISNA(VLOOKUP(B8,INDIRECT(VLOOKUP(A8,
$Q$1:$R$9,2)),2,TRUE)),"",VLOOKUP(B8,INDIRECT(VLOOKUP(A8,
$Q$1:$R$9,2)),2,TRUE))*D8

The formula works fine until it is copied down where there is no data entry
yet in columns A, B & D.
The formula looks up a table of weights, and when it find the unit weight it
multilies by the quantity shown in column D.

How can the above formula be modified to show a blank cell in column E when
Columns A, B & D don't have data in them yet?

Thank you in advance.
Serge

 

[Guest]

Try:

=IF(OR(A8="",B8="",D8=""),"",IF(ISNA(VLOOKUP(B8,INDIRECT(VLOOKUP(A8,$Q$1:$R$9,2)),2,TRUE)),"",VLOOKUP(B8,INDIRECT(VLOOKUP(A8,$Q$1:$R$9,2)),2,TRUE))*D8)

HTH

 

[Guest]

Hello Toppers,
It works great now.
Thank you verry much
Serge

 

[Guest]

And thank you ... I learned the neat trick of using INDIRECT with VLOOKUP.

 

[Guest]

Hello Toppers,
I cannot take the credit for this one. I had help in a previous posting.
But I guess this is how we all learn, by posting & acknowleging user group.
Serge