Quote:
Originally Posted by djmag
hi thanks for your reply,
through column name "S.No" at sheet "electrical" i can get items info on sheet "daily sheet" but i wont be able to get the same data via column name "location" at sheet "electrical" on sheet "daily sheet"....
i want to find the items via location rather than s.no..... actually it says "#REF" than "#N/A" any idea any help?
file attached...
|
The REF error you're seeing is because the range of cells your VLOOKUP was referring to have been deleted from the workbook.
If you're looking to use the "Location" rather than the "S.No" to look up values then you cannot use VLOOKUP as you have some values to the left of the reference value (Location).
What you can use is INDEX & MATCH.
Have a look at the attached. In row 13 I've added INDEX & MATCH formulas that do what I think you mean.
Let me know if I've misunderstood.