VLookUp

[babypink]

Hi

I have a Vlookup formula which took me about a week to work out..! Problem is, if the value in the Vlookup cell is BLANK the rest of the table throws in #NA

Qty Code Type Unit Total
2 A011001 8 tier super £10.00 £20.00
#N/A #N/A #N/A #N/A

My formula is =VLOOKUP(B16,picklist,2)

Please help

 

[onlyadrafter]

Hello,

DO you mean B16 is blank?

if so try

=if(B16="","",VLOOKUP(B16,picklist,2) )

 

[babypink]

Yes, everything in that column, if it is blank ie I only need to pick one line then the rest of row shows #NA

 

[babypink]

Wow that works, thank you so much, and it actually adds up the total, hurrrah....

Brilliant when you know what you are doing

 

[babypink]

Oh blimey I have now got this

Qty Code Type List Price Sub Total Disc Line Total
#VALUE! #VALUE!



The formula I use in Sub Total is =A2*E2

Under Disc I have a pick list with 30% or 40% (text)

Line total is =F1*(1-G1)

 

[babypink]

Oh blimey I have now got this

Qty Code Type List Price Sub Total Disc Line Total
#VALUE! #VALUE!



The formula I use in Sub Total is =A2*E2

Under Disc I have a pick list with 30% or 40% (text)

Line total is =F1*(1-G1)