need help

[djmag]

hi there,

hope all are good, well i am enclosing one of my file as i need help t
complete that file. there are two sheets called "electrical" "dail
sheet".

right now i am getting data via data validation and everything i
working fine, in that file i fetch data from electrical sheet but when
try to get data from column called "location" in sheet "electrical"
cant get any results it says "#NA" however the file right now you ca
see is working fine..

any idea any help?

regard

+-------------------------------------------------------------------
|Filename: Copy of Electrical PARTS.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=731
+-------------------------------------------------------------------

 

[Spencer101]

hi there,

hope all are good, well i am enclosing one of my file as i need help t
complete that file. there are two sheets called "electrical" "dail
sheet".

right now i am getting data via data validation and everything i
working fine, in that file i fetch data from electrical sheet but when
try to get data from column called "location" in sheet "electrical"
cant get any results it says "#NA" however the file right now you ca
see is working fine..

any idea any help?

regards

Hi,

We would need to see the file when it's not working rather than when i
is.
Could you attach a version with the #N/A result in it

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[djmag]

Hi

We would need to see the file when it's not working rather than when i
is
Could you attach a version with the #N/A result in it

hi thanks for your reply

through column name "S.No" at sheet "electrical" i can get items info o
sheet "daily sheet" but i wont be able to get the same data via colum
name "location" at sheet "electrical" on sheet "daily sheet"....

i want to find the items via location rather than s.no..... actually i
says "#REF" than "#N/A" any idea any help

file attached..

+-------------------------------------------------------------------
|Filename: Copy of Electrical PARTS.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=736
+-------------------------------------------------------------------

 

[Spencer101]

hi thanks for your reply,

through column name "S.No" at sheet "electrical" i can get items info o
sheet "daily sheet" but i wont be able to get the same data via colum
name "location" at sheet "electrical" on sheet "daily sheet"....

i want to find the items via location rather than s.no..... actually i
says "#REF" than "#N/A" any idea any help?

file attached...

The REF error you're seeing is because the range of cells your VLOOKU
was referring to have been deleted from the workbook.

If you're looking to use the "Location" rather than the "S.No" to loo
up values then you cannot use VLOOKUP as you have some values to th
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 & MATC
formulas that do what I think you mean.

Let me know if I've misunderstood

+-------------------------------------------------------------------
|Filename: Copy of Electrical PARTS.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=737
+-------------------------------------------------------------------