Combining Functions

[Guest]

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

 

[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