Vlookup Issue

[babypink]

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

 

[Sosul]

Because the 8 is not an index. You won't get the right data. You need an index in your lookup table, and that table has be sorted Ascending as well.

 

[VBA Noob]

Cross post here

http://www.excelforum.com/showthread.php?t=618601

VBA Noob