formula that will return cell next to certain value

**JENNYC** · 10-10-2007, 11:02 PM

Hello! Can anyone help me with a formula for the following scenario please...

Col A lists product codes
Col B lists prices

I need to search cells A1:A2000 and when it recognizes a certain code, return the price in the cell next to it (which would B"something")

Thank you!!

Jenny

**Paul** · 10-10-2007, 11:15 PM

Hi JennyC,

You could do this a few ways, the easiest probably being a VLOOKUP. For example:
=VLOOKUP(your_code,$A$1:$B$2000,2,0)

This will search for your_code in column A (A1:A2000) and if found it will return the value in the cell next to it (column B).

Another way would be to use
=INDEX($B$1:$B$2000,MATCH(your_code,$A$1:$A$2000,0))