Hi,
New here and hoping you can help me.
I have 4 columns of data and I need to be able to search for values in three columns, and return the 4th value if a match occurs. The data is as follows:
<tbody>
</tbody>
Let's say I have the data I want to search for in cells F1, G1, H1 I want a formula to search A:A FOR F1 data, B:B for G1 data, and H1 for C:C data, and if there is a match, return the number from D:D data.
For example, if
F1 = "FIRM A"
G1 = "2-4 FAMILY"
H1 = "Elevated on Crawlspace"
return would be 10, based on data above.
Does this makes sense?
Thank you for your help!
New here and hoping you can help me.
I have 4 columns of data and I need to be able to search for values in three columns, and return the 4th value if a match occurs. The data is as follows:
A | B | C | D |
FIRM A | SINGLE FAMILY | No Basement/Enclosure | 1 |
FIRM A | SINGLE FAMILY | With Basement | 2 |
FIRM A | SINGLE FAMILY | With Enclosure | 3 |
FIRM A | SINGLE FAMILY | Elevated on Crawlspace | 4 |
FIRM A | SINGLE FAMILY | Non-Elevated with Subgrade Crawlspace | 5 |
FIRM A | SINGLE FAMILY | Manufactured (Mobile) Home | 6 |
FIRM A | 2-4 FAMILY | No Basement/Enclosure | 7 |
FIRM A | 2-4 FAMILY | With Basement | 8 |
FIRM A | 2-4 FAMILY | With Enclosure | 9 |
FIRM A | 2-4 FAMILY | Elevated on Crawlspace | 10 |
FIRM A | 2-4 FAMILY | Non-Elevated with Subgrade Crawlspace | 11 |
FIRM A | 2-4 FAMILY | Manufactured (Mobile) Home | 12 |
FIRM B | OTHER RESIDENTIAL | No Basement/Enclosure | 13 |
<tbody>
</tbody>
Let's say I have the data I want to search for in cells F1, G1, H1 I want a formula to search A:A FOR F1 data, B:B for G1 data, and H1 for C:C data, and if there is a match, return the number from D:D data.
For example, if
F1 = "FIRM A"
G1 = "2-4 FAMILY"
H1 = "Elevated on Crawlspace"
return would be 10, based on data above.
Does this makes sense?
Thank you for your help!