Lookup Value and Return Field Based on a Condition

[dt293]

Hi all,

A quick Excel question for the guru's.

If the value in Action is "Add" I would like to lookup the Price on sheet2 based on whether the Code from sheet1 exists anywhere in the Code column on sheet2. The Price should be returned to the Price column on sheet1.

Please see attached spreadsheet
Here

Hopefully I have explained this well enough. Any questions please let me know.

Thanks in advance.

 

[Marcelo Branco]

Hi,

Welcome to the forum.

Formula in Sheet1 C2
=IF(A2="ADD",VLOOKUP(B2,Sheet2!$A$2:$B$8,2,0),0)

copy down

HTH

M.

 

[dt293]

Works perfectly. Thank you for your time.