If a cell matches another in a range then the value should match a given range of criteria

[daniel12346]

Been trying to solve this for a while but cannot find a solution. Please see image.

If the housetype stated in column B equals that of column R then the figure for Excavation & Concrete in column C should correspond to the Excavation figure in column S for the matching housetype.

Eg. If B10 = housetype A then C10 should = the housetype A Excavation figure so the value in C10 would = 10000.

I have tried loads of formulas from my own knowledge, and from researching but none do exactly what I need. I can get an IF forumla to work, but only works for the first 4 plots and any plots with same housetype there after just gives a #value error.

I hope this is enough information!
Untitled.png

[benishiryo]

welcome to the forum, daniel12346. it looks like VLOOKUP can do the job.
=VLOOKUP(B10,P:Q,2,0)

i developed a tool to help people learn VLOOKUP. try downloading this file here:
https://www.excelforum.com/tips-and-...-how-tool.html

[daniel12346]

Thank you, that worked perfectly!