I have the following table error
Qty Type Code List Price Sub Total Line Total
1 8 tier Special #N/A #N/A #N/A #N/A
It should read
1 8 tier Special A101001 £20.00 £40.00 £32.00
Under type my formula is =IF(B15="","",VLOOKUP(B15,picklist,2) )
My data table looks like
Type Code RRP
8 tier super A011001 £262.65
8 tier super 24hr A071019 £304.25
8 tier super 48hr A021002 £335.00
How come I am getting the #NA
Ta
Bookmarks