Combining Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top