my bet is your formula is wrong.

Either it's using the wrong cell to look for--or it's using the wrong range as
the lookup table.



run_PAFC wrote:

I am now puzzled as to why, what seems, exactly the same thing won't for
different data. I have 3 fields 'Part Number', 'Part description' and
'part price'. I want to shift the records in these fields to a
different area on the spreadsheet. I have all of the data in the combo
box and have created the lookups etc, however when I select a record
from the combo box 'part description' and 'part price' return with #N/A
where I want the correct values to be. Any suggestions as to why this
is occurring?

I have been puzzled all day so any help would be appreciated!

Thanks,
James

--
run_PAFC
------------------------------------------------------------------------
run_PAFC's Profile: http://www.excelforum.com/member.php...o&userid=24673
View this thread: http://www.excelforum.com/showthread...hreadid=382565

--

Dave Peterson