Vlookup
At least its more complex than I am used to!
Sheet 1 has a column with verbiage in it
Sheet 2 has a column of possibel verbiage with a second column of numeric values for the verbiage
On sheet 3, I want the numeric value for the verbiage in cell b19 on Sheet1
Long way, create a new column on sheet1, run a VLookup to insert the numeric value into the new column, then do an "equals" on sheet 3 that point to the Vlookup results.
How can I get the value onto sheet3 without creating the extra column?
Last edited by amthyst826; 02-18-2010 at 02:14 PM.
You mean
=Vlookup(Sheet1!B19,Sheet2!A:B,2,FALSE)
While in Sheet3, this looks up value from Sheet1!B19 and finds it in column A of Sheet2! returning number from Column B of Sheet2 at corresponding point...
If it is indeed numeric values to return.. you can also use
=Sumif(Sheet2!A:A,Sheet1!B19,Sheet2!B:B)
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
The first was what I needed! Thanks so much!!
(I'll go check out how to mark this solved!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks