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?