Looking and matching vaules to return another vaule

J

JakeMan

I need help in creating a formula to look for a row that has two matching
items for example must match A8 and D6 on sheet 1 but must look from an array
on sheet 2. If that matches the values in colum A and B on sheet 2 then it
gives me the vaule in colum G on sheet 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

Match Copy/Paste Macro almost there 0
Search cell value in same column 3
COUNTIF + ADDRESS Issue 1
Look up with 2 colums and 3rows 0
Index and Match 5
excel formula is returning incorrect values 0
Look up, return value 5
VLookup or Macro? 0

Top