Lookup and filtering

[rana_shaker]

Hi ..
I am new to excel .. I made a sheet with lookup function cells that look and return data from another sheet in the same workbook
when I tried to sort the data .. the lookup function didn't work correctly .. and I can't fixt it ..

can u help me ??

[NBVC]

You sorted the data in the lookup table?

If so, then LOOKUP() needs data to be sorted in ascending order. You can revert to VLOOKUP() instead if you want to find exact matches in a sorted/unsorted list.

e.g.

if you had =LOOKUP(A1,X1:Z1)

then change to =VLOOKUP(A1,X1:Z1,3,FALSE)

[rana_shaker]

I sorted the data in the original table ( table of data ) that I return the data from

[NBVC]

Try the VLOOKUP then. See if it gets fixed.

[rana_shaker]

unfortunately it is not working

[NBVC]

If you can, attach a sample showing what you are experiencing.

[rana_shaker]

thanks a lot ... I solve it using Index and match functions

thank you for helping