Need help with Lookup

[Benny RC]

Hi,

I have a table that shows apartment numbers in column 1 (in ascending order), and a parking space number in column 2, if a parking space has been assigned to the tenant in that apartment. The parking assignments could change any day.

I am trying to create a new table under a new tab, where parking space numbers are in column 1 (in ascending order), and if the space is assigned to an apartment, then the apartment number would show in column 2.

I have used the formula LOOKUP(A7,E7:F157,B7:B157) to lookup an apartment number for any parking space, but I keep getting #N/A. I have also tried VLookup and HLookup, but had no success.

I would appreciate any help.

 

[Aladin Akyurek]

Try...

=INDEX(ApartmentRange,MATCH(ParkingSpace,ParkingSpaceRange,0))

 

[dvananthan]

Sir
you can try this Same as Aladin but slight modification

=IF(ISNA(INDEX(A1:A11,MATCH(target cell ref,B1:B11,0))),"Vacant",(INDEX(A1:A11,MATCH(G1,B1:B11,0))))

a1:a11 - apartment numbers(choose range you want)
b1:b11 - parking spaces numbers(choose range you wan)
target cell reference is the cell where you want the result in the other worksheet

regards
P>S> i got inspiration from Aladin and thanks to him! i am in learning stage so excuse if i have made mistake