Help with lookup

  • Thread starter Thread starter DavidObeid
  • Start date Start date
D

DavidObeid

How exactly do I get lookup to work for me?

I have a reasonably large array (B9:AE2509) of values.

Column A (A9:A2509) contains the numbers 0.0 to 25.0 in increments o
0.01.

Row 8 (B8:AE8) contains the numbers 1 to 30.

How do I go about finding out what is at the intersection of (say) th
row containing 12.07 and the column containing 25 without scrollin
through the sheet each time?

I am sure there must be a simple way to do this. Any tips? (If th
solution is VBA, can I be given idiot proof instructions about how t
load the VBA? I am very much a VBA beginner.)

Regards,

David Obei
 
David

My solution would be to use the "Index" function - you
need to enter the array (B9:AE2509), row number and
column number - the answer will be what is at that
junction.

=INDEX(B9:AE2509,A1,B1)
where A1 = Row Number and B1 = Column Number

You may need to use a formula to calculate what row
number or column number your specific values reside at.

Eg. multiply the number 0.18 x 100 to get row 18 in the
array.

Hope this helps, Paddy
 
Back
Top