V-Lookup (3 in 1)?

[elfiky]

How to V-Look-Up multiple fields into one field. For example:

(John, Peter, & Maria) are in one line item. However, thier values are seperate in the other sheet (John=2, Peter=3, & Maria=5).

How can I do a v-lookup to add the sum of (10) matching the ONE line item (John,Peter, & Maria)

[zbor]

Can you upload example?

[teylyn]

(John, Peter, & Maria) are in one line item

What does that look like in your workbook?

However, thier [sic!] values are seperate [sic!] in the other sheet (John=2, Peter=3, & Maria=5).

What does that look like in your workbook?

Just re-iterating zbor's request. This is too vague to be answered without seeing your file.

Post your file and be sure to mock up the expected results, explaining the logic that leads to them.

[elfiky]

Attached please find a sample excel file. Your solution to this file is very helpful. Thanks

[zbor]

Try to sum both VLOOKUP's separately:

=IF($D$5="owned";VLOOKUP("Architect and Engineer Services";'Large Project Estimator'!$B$12:$G$74;6;FALSE);0)+IF($D$5="Leased";VLOOKUP("Architect and Engineer Services";'Large Project Estimator'!$B$12:$G$74;5;FALSE);0)

(replace ; with , if you get error)