Microsoft Office Forums Need Value rom one sheet to another sheet with out using the Vlookup function.

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-03-2019, 05:14 AM
vikaskhengre vikaskhengre is offline Need Value rom one sheet to another sheet with out using the Vlookup function. Windows 10 Need Value rom one sheet to another sheet with out using the Vlookup function. Office 2019
Novice
Need Value rom one sheet to another sheet with out using the Vlookup function.
 
Join Date: Apr 2019
Posts: 4
vikaskhengre is on a distinguished road
Default Need Value rom one sheet to another sheet with out using the Vlookup function.

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!
Reply With Quote
  #2  
Old 04-03-2019, 05:15 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need Value rom one sheet to another sheet with out using the Vlookup function. Windows 7 64bit Need Value rom one sheet to another sheet with out using the Vlookup function. Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,387
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Hi and welcome
no sheet attached
What's wrong with Vlookup?
Try an INDEX/MATCH combination
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 04-03-2019, 05:20 AM
vikaskhengre vikaskhengre is offline Need Value rom one sheet to another sheet with out using the Vlookup function. Windows 10 Need Value rom one sheet to another sheet with out using the Vlookup function. Office 2019
Novice
Need Value rom one sheet to another sheet with out using the Vlookup function.
 
Join Date: Apr 2019
Posts: 4
vikaskhengre is on a distinguished road
Default

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
File Type: xlsx Values without Vlookup.xlsx (14.1 KB, 4 views)
Reply With Quote
  #4  
Old 04-03-2019, 08:12 AM
Marcia's Avatar
Marcia Marcia is offline Need Value rom one sheet to another sheet with out using the Vlookup function. Windows 7 32bit Need Value rom one sheet to another sheet with out using the Vlookup function. Office 2013
Competent Performer
 
Join Date: May 2018
Location: Philippines
Posts: 202
Marcia is on a distinguished road
Default

I played on both VLOOKUP and INDEX/MATCH as suggested by the moderator, both approaches return the same value.
Attached Files
File Type: xlsx Copy of Values without Vlookup-1.xlsx (15.3 KB, 4 views)
Reply With Quote
  #5  
Old 04-03-2019, 10:37 AM
vikaskhengre vikaskhengre is offline Need Value rom one sheet to another sheet with out using the Vlookup function. Windows 10 Need Value rom one sheet to another sheet with out using the Vlookup function. Office 2019
Novice
Need Value rom one sheet to another sheet with out using the Vlookup function.
 
Join Date: Apr 2019
Posts: 4
vikaskhengre is on a distinguished road
Default

Hi Marcia,


Thanks for your valuable reply,


your solution helps me a lot.


Regards
Reply With Quote
  #6  
Old 04-03-2019, 11:24 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need Value rom one sheet to another sheet with out using the Vlookup function. Windows 7 64bit Need Value rom one sheet to another sheet with out using the Vlookup function. Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,387
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

If this solves your problem, please mark thread "solved" ( see "Thread tools").
Thanks
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert VLOOKUP values to text on another sheet AUTOMATICALLY Lady18 Excel 5 09-10-2016 03:12 AM
Need Value rom one sheet to another sheet with out using the Vlookup function. How to convert VLOOKUP values to text on another sheet AUTOMATICALLY Lady18 Excel 1 09-10-2016 12:15 AM
Need Value rom one sheet to another sheet with out using the Vlookup function. How To Move Focus From VLOOKUP Result to Report Sheet swindon.expat Excel 2 04-10-2016 12:15 AM
Populate sheet 3 with data from sheet 1 and sheet 2 speck Excel Programming 0 01-14-2015 07:54 AM
Need Value rom one sheet to another sheet with out using the Vlookup function. VLOOKUP in different sheet. santors71 Excel 1 12-07-2011 09:20 AM


All times are GMT -7. The time now is 09:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft