Formula Question - Don't know what to call it

jaysh

New Member
Joined
Jul 30, 2006
Messages
16
I have a quick question. I dont know exactly what this would be called so I unfortunatley could not search.

Basically, I have 2 sheets.

Example

Sheet 1

1 A
2 B
3 C

Sheet 2

2 ?
2 ?
3 ?
1 ?
1 ?
2 ?
3 ?
2 ?

What I would like to do, is replace column b on sheet 2 w/ the corresponding information from sheet 1.

Answer would be like this:

2 B
2 B
3 C
1 A
1 A
2 B
3 C
2 B

But a simple IF would not work for me because I have about 100 different variables.

Any help would be appreciated.
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
In case the values in column A are not index values (positions pointing to column B)...

B1, Sheeet2

=INDEX(Sheet1!$B$1:$B$3,MATCH(A1,Sheet1!$A$1:$A$3,0))
 

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
I have a quick question. I dont know exactly what this would be called so I unfortunatley could not search.

Basically, I have 2 sheets.

Example

Sheet 1

1 A
2 B
3 C

Sheet 2

2 ?
2 ?
3 ?
1 ?
1 ?
2 ?
3 ?
2 ?

What I would like to do, is replace column b on sheet 2 w/ the corresponding information from sheet 1.

Answer would be like this:

2 B
2 B
3 C
1 A
1 A
2 B
3 C
2 B

But a simple IF would not work for me because I have about 100 different variables.

Any help would be appreciated.
Here's another one...

Assuming your data on Sheet1 is in the range A2:B4.

Your data on Sheet2 is in the range A2:A9.

Enter this formula in Sheet2 B2 and copy down as needed:

=VLOOKUP(A2,Sheet1!A$2:B$4,2,0)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,197
Messages
5,527,369
Members
409,758
Latest member
Smith79

This Week's Hot Topics

Top