Lookup:Vlookup and Hlookup

[PaxtonK]

How do I return the value of a cell that is found by using the value in A1 and A2. For example A1 = 3 and A2 = 4, the value that is returned would be that in Column 3 Row 4?

I've found Vlookup and Hlookup but need to use both.

Thanks again.

[jasoncw]

Try using the INDIRECT function:

=INDIRECT("R"&A2&"C"&A1,FALSE)

HTH

Jason

[daddylonglegs]

=INDEX($1:$65536,A2,A1)

or perhaps

=OFFSET(A1,A2-1,A1-1)