Hi,
Having trouble with this formula:
But I don't know what is wrong. Basically, I have a sheet with all employees, by last name, first name, salary. I am trying to make it so that on the other sheets, it pulls this value from this sheet.
Please Login or Register to view this content.
Can any one spot what the issue is?
use column NUMBER in current range:
Formula:
Please Login or Register to view this content.
Best Regards,
Kaper
Hi
VLOOKUP does not works like that. See the link and if you still have problems upload a small sample workbook
http://www.contextures.com/xlFunctions02.html
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Perfect, thank you both, I thought I had looked it up, but just missed that the value of the column is supposed to be the column number within the range, makes much more sense. Thank you.
One more quick question, is there a way to do 2 cells together, I can't get:
to work, I have tried putting A5:B5 in Brackets, and I have tried using &. Is this not possible, it's just surname is in one column and first name in another, I would like it to differentiate between the 5 smiths we have working here.Please Login or Register to view this content.
Kind regards
Rob
An idea is to use 1 helper-hidden column(a2&b2) in eatch sheet concatenating(=a2&b2) the names and use these columns as reference in your formula and another one, is to use an ARRAY INDEX&MATCH formula.
Thanks Fortis, I used the helper hidden column in the end.
You are welcome and thanks for the feedback.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks