Lookup Y&X show Z but only in A & B are correct

J

JK494

Help,
I am trying to create a spreadsheet that numpties can use only to be
stumped myself!

I want to look up a value in column X and Y show column Z, but only if
column B and C are both correct. ie if b = engineer and c= upper then it
needs to look for engineer in X and upper in Y and display the rate in Z

Columns B&C i will use as a drop down selection box to get the correct
titles and grade.

X Y Z
Engineer Upper £3
Engineer Middle £2
Engineer Lower £1
Foreman Upper £1.4
Foreman Lower £1.2
 

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

X,Y,Z values to be extracted and posted respectively in excel 5
Lookup in a matrix (with x and y headings) based on value x and y 2
Comparing a cell value with a range in a table and displaying a response 0
% of subtotal in pivot table 1
In Office 2007 the single quotation mark changes the following let 11
Can Excel describe a function in two variables: y = f(x,z) 3
product info from different data sources 1
matching data from different sources 2

Top