Combining Functions

R

Ron F

Hi all,

I have a question and could use all the help I can get. If column A, cell A2 has "abc" in it and column F, cell F1 has "xyz" in it, and I enter any numeric value in cell F2, is there a function or combination of functions that will automatically look in cell A2 and F1, then based on those entries, return the numeric value I entered in cell F2 to a specific location in another part of the worksheet?

Any help is greatly appreciated.
TIA
Ron
 
F

Frank Kabel

Hi Ron
not quite sure if this is what you want?. Put the following formula in
your target cell:
=IF(AND(A2="abc",F1="xyz"),F2,"")

but i think you are more looking for a kind of double lookup. That is:
First search in column A for your value and then return the value from
the column with the correct value in row 1. So something like:
=INDEX($A$2:$F$999,MATCH("abc",$A$2:$A$999,0),MATCH("xyz",$A$1:$F$1,0))

HTH
Frank
 

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

Top