If a value occurs in a list the return a record on the same

Nathanm · May 10th, 2002, 05:35 AM

HELP

I have a list of unique reference numbers in two lists. Each list has info relating to the unique number and I need to match some of them up.

Eg if reference in list 1 occurs in list 2 then tell me the value for that reference in another column.

I was thinking something like an if cell ref = same ref in a range then tell the figure in column D

Thanks in advance

NM

Ricky Morris · May 10th, 2002, 05:52 AM

Try Vlookup.

=vlookup(lookupvalue,table,columnnumber,false)

May 10th, 2002, 05:52 AM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Try Vlookup. =vlookup(lookupvalue,table,columnnumber,false) __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 05:35 AM	#1
Nathanm New Member Join Date: Apr 2002 Posts: 4	HELP I have a list of unique reference numbers in two lists. Each list has info relating to the unique number and I need to match some of them up. Eg if reference in list 1 occurs in list 2 then tell me the value for that reference in another column. I was thinking something like an if cell ref = same ref in a range then tell the figure in column D Thanks in advance NM