Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which formula to use?
Hi,
I am trying to lookup & match a table of data from 2 different sheets. (meaning if sheet 1-Name,price, colour is equal to sheet 2-name,price,colour) Once the data matches, it should return a reference id to me. See below example: Sheet 1 Name Price Colour Sheet 2 Name Price Colour Reference id Can someone advise what formula I should use? |