Hi Team,

I need to find particulate value from one sheet to another sheet with out using the Vlookup function.

Attached sheet will give you the brief view about the requirement.


Your help in this regards will be highly appreciated.




Thanks!

Hi and welcome
no sheet attached
What's wrong with Vlookup?
Try an INDEX/MATCH combination

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi,


Somehow its not working properly, however index match function is a good idea but I am not able to applying the same.



Kindly find the attached file for your reference.


Thanks!

Attached Files

Values without Vlookup.xlsx (14.1 KB, 10 views)

I played on both VLOOKUP and INDEX/MATCH as suggested by the moderator, both approaches return the same value.

Attached Files

Copy of Values without Vlookup-1.xlsx (15.3 KB, 11 views)

Hi Marcia,


Thanks for your valuable reply,


your solution helps me a lot.


Regards

If this solves your problem, please mark thread "solved" ( see "Thread tools").
Thanks

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post