hello )) I want to know if it is possible to fill a row automatically. I"m sure it is, but don't know how )).
I'l explain.
fro example if I have names of students in one row, row A for example and there addresses in row B. and in another sheet I have names in a different sequence. can i transfer addresses of students from first sheet.
Last edited by gillo; 11-01-2017 at 03:42 AM.
Hi,
Welcome to the Forum.
Yes, it is possible with the help of a simple VLOOKUP or INDEX/MATCH functions.
If you need further help, can you post a sample file here in excel format demonstrating your requirement? Remember to desensitize the file before upload by deleting confidential info from the file, if any.
Click on "Go Advanced" & use "Manage Attachments" option to upload the file.
A simple example for you
Select a name from dropdown in column A and see what happens
formula in B2 copied down:
Formula:
Please Login or Register to view this content.
VLOOKUP wrapped in IFERROR to prevent error in cell if formula cannot find the name
VLOOKUP(A2,Sheet2!A:B,2,0)
VLOOKUP(look for this value,look for it here,return 2nd column,0=EXACT MATCH)
Last edited by kev_; 11-01-2017 at 03:40 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
thank you guys.
both answer was very helpful for me
You are welcome - thanks for the rep
If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks