Hi
I need a formula that will reference a specific value located in A1:A1000 on worksheet 1, locate the same value in A1:A1000 on worksheet 2 and return the value from Column C on worksheet 2 for the same record.
I've done this before, a long time ago, and can't recall now. Any help appreciated.
Functions to use:
VLOOKUP()
LOOKUP()
INDEX/MATCH()
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Could someone please give me an example code for the above. I've added an attachment with an example worksheet.
The formula is to go in col E of the Dept worksheet. I want to be able to search the same value in column A on the worksheet "Dept" and find the same value in column A of the worksheet "Vehicle" and the result will be the corresponding value in the vehicle make column of the same record.
Hope this makes sense. (Basically I want to find the vehicle make of each person).
Insert on E2:
=VLOOKUP(A2,Vehicle!$A$2:$E$5,5,FALSE)
Then copy down
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
Perfect, thanks Ron.Originally Posted by ron2k_1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks