Hi,
I have a base data in sheet1 with the unique ID. I have a set of unique ID's in another excel and it should pull the details from base data of sheet1 when i copy and paste those unique ID's(from another excel) in sheet2 of base data excel. It should pull all the respective column details of that unique ID.
Please refer the attachment for sample base data and expected result.
Can anyone help me to get this formula.
Thanks
Karthikeyan NB
Hi Arun,
As per my understanding,
Why u are not using, simple "vllokup" for it.. or u want something else...
Best Regards,
Jitendra.
Hi Arun,
As per my understanding,
Why u are not using, simple "vllokup" for it.. or u want something else...
Best Regards,
Jitendra.
See the file..Originally Posted by udprocks
Best Regards,
Jitendra
Hi,
B2=Formula:
Please Login or Register to view this content.
and drag it down and across
☚ Click ★ just below left if it helps, Boo?ath?
SOLVED
Here is your solution
Just download following file
If you like then appreciate by clink on (star) * in left bottom of this message
Here are two formulae that you can enter into Expected Result'!B2 and copy across and down as far as you need.
VLOOKUP:
Formula:Please Login or Register to view this content.
INDEX AND MATCH:
Formula:Please Login or Register to view this content.
Choose the one that works best for you.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks