Populate column based on data in other cells
 

I am trying to populate "Column E" in "Tab_1" with data from "Tab_2".
These are two tabs in the spreadsheet.

Tab_1:
- Column C, has a value say 12345a.
- Column E is blank.

Tab_2:
- Column A has a list which contains 12345a
- Column B has another value, one for each item in Column A

I want Column E in Tab_1 to be populated with the value in Tab_2
Column B where Tab_1:Column C matches Tab_2:Column A. There will be
only one match as each value in Tab_2 Column A is unique. Was
thinking a Macro could be pasted down Column E in Tab_1 to facilitate
this, but wasn't sure how to code it. Any suggestions?

Thanks.

JR

Populate column based on data in other cells
 

=VLOOKUP(C2,'Tab_2!'$A$1:$B$5000,2,0)


copy down



--
Regards,

Peo Sjoblom



"JR" wrote in message
oups.com...
I am trying to populate "Column E" in "Tab_1" with data from "Tab_2".
These are two tabs in the spreadsheet.

Tab_1:
- Column C, has a value say 12345a.
- Column E is blank.

Tab_2:
- Column A has a list which contains 12345a
- Column B has another value, one for each item in Column A

I want Column E in Tab_1 to be populated with the value in Tab_2
Column B where Tab_1:Column C matches Tab_2:Column A. There will be
only one match as each value in Tab_2 Column A is unique. Was
thinking a Macro could be pasted down Column E in Tab_1 to facilitate
this, but wasn't sure how to code it. Any suggestions?

Thanks.

JR

Populate column based on data in other cells
 

In E1: =VLOOKUP(A1,Tab_2!$A$1:$B$100,2)
This will look to find the value found in Tab_1, A1 in Tab_2 range A1 to
B100 and return the value it finds in column B in Tab_2.
Copy down as necessary

--
Traa Dy Liooar

Jock


"JR" wrote:

I am trying to populate "Column E" in "Tab_1" with data from "Tab_2".
These are two tabs in the spreadsheet.

Tab_1:
- Column C, has a value say 12345a.
- Column E is blank.

Tab_2:
- Column A has a list which contains 12345a
- Column B has another value, one for each item in Column A

I want Column E in Tab_1 to be populated with the value in Tab_2
Column B where Tab_1:Column C matches Tab_2:Column A. There will be
only one match as each value in Tab_2 Column A is unique. Was
thinking a Macro could be pasted down Column E in Tab_1 to facilitate
this, but wasn't sure how to code it. Any suggestions?

Thanks.

JR