conditional format in look up

D

DeeExpus

Hi all.

Im using a look up table in an order form so that you input a product
code and it pulls in the description, cost and sell price. eg.

Sheet 1
A_B_C_D_E
Quantity_Code_Description_Sell_Cost

lookup content:
A_B_C_D_E
Code_Description_Cost_Sell

sooo, lets say the lookup content is:
A_B_C_D_E
100_Item1_£10_£20
100_Item2_£11_£21
100_Item3_£12_£22

Bearing in mind there are 6000 products, the problem I sometimes have
is that if I put a "Code" in incorrectly, it will bring up the nearest
item(or at least the wrong item) and I occaisionally miss it resulting
in a duff order and much chastising and beating!

I need to conditionally format the Description cell so that if I
mistype the code the cell with the description will highlight.
Basically, the formatting of the description cell needs to check that
the content it is displaying and he code adjacent to it, match the two
adjacent items in the look up content.

Does this make sense? I hope so!

Thanks in advance

Andy
 
K

kassie

To start with, syntax for VLOOKUP is =VLOOKUP(<ref cell>,<Lookup
Range>,<Offset>,FALSE or TRUE). True will do what you say. If ommitted , it
will do what you say. FALSE wil result in a #N/A as result where you make a
typo. So no chastising, no beating and no duff orders!
 
Top