Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Forgot formula for auto copy of cell value...
Hi...thanks in advance for your help.
Let's say I have two tabs. The formula is going in a cell B1 in tab1. In Tab 2, col A contains names, col B contains address, col C contains title...etc. I would like to manually enter one of the names in Tab 1, cell A1, and have cell B1 automatically copy the corresponding data from say, Col B in Tab 2. No calculations, just straight copy. (logic would be "if the value I entered in Tab1 A1 matches any of the names in Tab2 Col A, then copy the person's address here). I've used it before...and it's straightforward...but this old brain just didn't hang on to it. This was not a code or macro thing...just a straight formula you write in a cell. THANKS EVER SO MUCH!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Forgot formula for auto copy of cell value...
=VLOOKUP(A1,Tab2!A:B,2,0) would do it.
=IF(A1="","",VLOOKUP(A1,Tab2!A:B,2,0)) would show a blank cell until you enter a value in A1. "Stilla" wrote: Hi...thanks in advance for your help. Let's say I have two tabs. The formula is going in a cell B1 in tab1. In Tab 2, col A contains names, col B contains address, col C contains title...etc. I would like to manually enter one of the names in Tab 1, cell A1, and have cell B1 automatically copy the corresponding data from say, Col B in Tab 2. No calculations, just straight copy. (logic would be "if the value I entered in Tab1 A1 matches any of the names in Tab2 Col A, then copy the person's address here). I've used it before...and it's straightforward...but this old brain just didn't hang on to it. This was not a code or macro thing...just a straight formula you write in a cell. THANKS EVER SO MUCH!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Forgot formula for auto copy of cell value...
Look up VLookup in Help. HTH Otto
"Stilla" wrote in message ... Hi...thanks in advance for your help. Let's say I have two tabs. The formula is going in a cell B1 in tab1. In Tab 2, col A contains names, col B contains address, col C contains title...etc. I would like to manually enter one of the names in Tab 1, cell A1, and have cell B1 automatically copy the corresponding data from say, Col B in Tab 2. No calculations, just straight copy. (logic would be "if the value I entered in Tab1 A1 matches any of the names in Tab2 Col A, then copy the person's address here). I've used it before...and it's straightforward...but this old brain just didn't hang on to it. This was not a code or macro thing...just a straight formula you write in a cell. THANKS EVER SO MUCH!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Forgot formula for auto copy of cell value...
Oh thank you for reminding me of Vlookup!!! For this the reference data
MUST be in the first column, right? Is there any other formula for using any other column but the first as a reference? Say, if a value in Col Z in Tab 2 is "Mr. Jones", then copy his address from Col B in Tab2) Thanks so much! "Sean Timmons" wrote: =VLOOKUP(A1,Tab2!A:B,2,0) would do it. =IF(A1="","",VLOOKUP(A1,Tab2!A:B,2,0)) would show a blank cell until you enter a value in A1. "Stilla" wrote: Hi...thanks in advance for your help. Let's say I have two tabs. The formula is going in a cell B1 in tab1. In Tab 2, col A contains names, col B contains address, col C contains title...etc. I would like to manually enter one of the names in Tab 1, cell A1, and have cell B1 automatically copy the corresponding data from say, Col B in Tab 2. No calculations, just straight copy. (logic would be "if the value I entered in Tab1 A1 matches any of the names in Tab2 Col A, then copy the person's address here). I've used it before...and it's straightforward...but this old brain just didn't hang on to it. This was not a code or macro thing...just a straight formula you write in a cell. THANKS EVER SO MUCH!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Forgot formula for auto copy of cell value...
=INDEX(Tab2!A:Z,MATCH(A2,Tab2!Z:Z),2)
Should return your value. this assumes your names in column Z are unique. "Stilla" wrote: Oh thank you for reminding me of Vlookup!!! For this the reference data MUST be in the first column, right? Is there any other formula for using any other column but the first as a reference? Say, if a value in Col Z in Tab 2 is "Mr. Jones", then copy his address from Col B in Tab2) Thanks so much! "Sean Timmons" wrote: =VLOOKUP(A1,Tab2!A:B,2,0) would do it. =IF(A1="","",VLOOKUP(A1,Tab2!A:B,2,0)) would show a blank cell until you enter a value in A1. "Stilla" wrote: Hi...thanks in advance for your help. Let's say I have two tabs. The formula is going in a cell B1 in tab1. In Tab 2, col A contains names, col B contains address, col C contains title...etc. I would like to manually enter one of the names in Tab 1, cell A1, and have cell B1 automatically copy the corresponding data from say, Col B in Tab 2. No calculations, just straight copy. (logic would be "if the value I entered in Tab1 A1 matches any of the names in Tab2 Col A, then copy the person's address here). I've used it before...and it's straightforward...but this old brain just didn't hang on to it. This was not a code or macro thing...just a straight formula you write in a cell. THANKS EVER SO MUCH!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Forgot formula for auto copy of cell value...
Perfect! Just what I was looking for! Actually, I'm going to suggest that
we work from #ID numbers vs from names.....since names may not be unique. Thanks a million! "Sean Timmons" wrote: =INDEX(Tab2!A:Z,MATCH(A2,Tab2!Z:Z),2) Should return your value. this assumes your names in column Z are unique. "Stilla" wrote: Oh thank you for reminding me of Vlookup!!! For this the reference data MUST be in the first column, right? Is there any other formula for using any other column but the first as a reference? Say, if a value in Col Z in Tab 2 is "Mr. Jones", then copy his address from Col B in Tab2) Thanks so much! "Sean Timmons" wrote: =VLOOKUP(A1,Tab2!A:B,2,0) would do it. =IF(A1="","",VLOOKUP(A1,Tab2!A:B,2,0)) would show a blank cell until you enter a value in A1. "Stilla" wrote: Hi...thanks in advance for your help. Let's say I have two tabs. The formula is going in a cell B1 in tab1. In Tab 2, col A contains names, col B contains address, col C contains title...etc. I would like to manually enter one of the names in Tab 1, cell A1, and have cell B1 automatically copy the corresponding data from say, Col B in Tab 2. No calculations, just straight copy. (logic would be "if the value I entered in Tab1 A1 matches any of the names in Tab2 Col A, then copy the person's address here). I've used it before...and it's straightforward...but this old brain just didn't hang on to it. This was not a code or macro thing...just a straight formula you write in a cell. THANKS EVER SO MUCH!! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Forgot formula for auto copy of cell value...
ALWAYS use unique identifiers when possible. Avoids many issues. :-)
"Stilla" wrote: Perfect! Just what I was looking for! Actually, I'm going to suggest that we work from #ID numbers vs from names.....since names may not be unique. Thanks a million! "Sean Timmons" wrote: =INDEX(Tab2!A:Z,MATCH(A2,Tab2!Z:Z),2) Should return your value. this assumes your names in column Z are unique. "Stilla" wrote: Oh thank you for reminding me of Vlookup!!! For this the reference data MUST be in the first column, right? Is there any other formula for using any other column but the first as a reference? Say, if a value in Col Z in Tab 2 is "Mr. Jones", then copy his address from Col B in Tab2) Thanks so much! "Sean Timmons" wrote: =VLOOKUP(A1,Tab2!A:B,2,0) would do it. =IF(A1="","",VLOOKUP(A1,Tab2!A:B,2,0)) would show a blank cell until you enter a value in A1. "Stilla" wrote: Hi...thanks in advance for your help. Let's say I have two tabs. The formula is going in a cell B1 in tab1. In Tab 2, col A contains names, col B contains address, col C contains title...etc. I would like to manually enter one of the names in Tab 1, cell A1, and have cell B1 automatically copy the corresponding data from say, Col B in Tab 2. No calculations, just straight copy. (logic would be "if the value I entered in Tab1 A1 matches any of the names in Tab2 Col A, then copy the person's address here). I've used it before...and it's straightforward...but this old brain just didn't hang on to it. This was not a code or macro thing...just a straight formula you write in a cell. THANKS EVER SO MUCH!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I forgot my password, how do I open a sheet if I forgot the pass | Excel Worksheet Functions | |||
Forgot Password on a sheet and tab - how do I copy and paste | Excel Worksheet Functions | |||
Auto copy of data to first available cell | Excel Discussion (Misc queries) | |||
auto copy old data to new cell | New Users to Excel | |||
Auto copy dates from one cell to another | Excel Discussion (Misc queries) |