VLOOKUP formula with "#VALUE"

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top