How to match fields and retrive data

  • Thread starter Thread starter Piotr
  • Start date Start date
P

Piotr

Hi I have one sheet like:

0123 Food
0124 Drinks
..... ......

where I store product informations

in another sheet I have pivot table where I have information about the
price:

0124 45$
0123 3$
..... ..

How can I make excell to look in second sheet for particular value and
retrive the price in first sheet ?

Please help me with this as I have no idea
 
Thank You,
I was trying this function but as I see I did in wrong way,
thanks again for help.



U¿ytkownik Frank Kabel napisa³:
 
Hi,
Another alternative, a little tougher to grasp at first, is using the
INDEX / MATCH functions. The website Frank showed also has examples of
how to do this too. The advantage of INDEX / MATCH is that column order
and sorting conventions are not an issue, which with VLOOKUP can be a
little temperamental.
Pseudo-Example:
=INDEX("Range of Cell Values", MATCH("Range to Match", "Cell
to Match", False), 1)
See: http://www.contextures.com/xlFunctions03.html#IndexMatch
In the end both work just fine. Good Luck! Lonnie M.
 
Back
Top