vlookup with if statement?

K

KC

Hiring tab: Column K: Band (either 5,6,7 or 8); Column D: Source (either ITSO
or GMT), Column M: Country (Buenos Aires, etc)

List tab: Column I: Band (either 5,6,7 or 8); Column M: GMT Salaries;
Column N: ITSO salaries; Column O: Buenos Aires Salaries

In Column X on the Hiring tab, I want to put the salary that matches the
criteria that is in the columns above.

Basically, Look up whats in column K and column D, and IF Buenos Aires is
NOT in column M, then lookup the salary in the list tab that corresponds with
the criteria on the Hiring tab. However, if column M does = Buenos Aires,
then just look at the Band and match it with the band on the List tab and
return the correct salary from Column O of the List tab

I was using the following formula until someone changed the rules lol and
now this formula doesn't cut it. LOL
=IF(ISNA(VLOOKUP(K7,List!I:K,3,FALSE)),"",VLOOKUP(K7,List!I:K,3,FALSE))

Thanks in advance for your help! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT with Date? 3
Array counting 3
Vlookup with an Arrayformula.... HELP! 0
IF and VLOOKUP 2
IF function for a value range 6
IF Statement Problem 4
VLOOKUP Help 3
Another VLOOKUP Problem 8

Top