View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Thierry
 
Posts: n/a
Default alternative to VLOOKUP

Hi,

What I am looking for is an alternative for the function VLOOKUP.
I want to to exactly the operation this function performs, only I do
not have the option to sort the data in my array.

I am trying the following:

Sheet 2; cel A1:

= 'Sheet 1'!A14

Sheet 2; cel B1:

=INDIRECT("'Sheet 1'!C"&ROW(B3))

Condition: The cel B1 in sheet 2 has to be a reference to Sheet 2 cel
A1.

My problem is that I cannot get the rownumber from Sheet 1 (= 14 in my
example).

Thanks for any help!!