Vlookup to SHow corresponding info

[CreativeRova]

Hi,

I have a table of info in in Column a has a bunch numbers all different. Column B shows names. i then have a separate spreadsheet with numbers similar to first spread sheet column A.

I want to check that the number that is in spreadsheet 2 if it appears in spreadsheet 1 then to show the name that is next to the number. see below.

1254		John Smith		269	Steph Johnson
3562		Bob Wright		4259	Belinda Carter
4541		Simon Jones		43637	Simone Hobbs
3254		Felix Unger		3562	Joe Blog
3526		Joe Blog
269		Steph Johnson
4259		Belinda Carter
43637		Simone Hobbs
12498		Sarah Fogg

<tbody>
</tbody>

As you can see column C has a number in itso i think i need to vlookup that number to column A, if its there then show column B next to that number.

 

[BrianM]

In Sheet2 (assuming the numbers are in column A) =VLOOKUP(A2,Sheet1!A:B,2,FALSE)

 

[FDibbins]

Your explanaition and cell refs are a bit confusing, but perhaps this will get you heading in the right direction?

As you can see column C has a number in

	A​	B​	C​	D​	E​	F​
3​	1254	not found	John Smith		269	Steph Johnson
4​	3562	Joe Blog	Bob Wright		4259	Belinda Carter
5​	4541	not found	Simon Jones		43637	Simone Hobbs
6​	3254	not found	Felix Unger		3562	Joe Blog
7​	3526	not found	Joe Blog
8​	269	Steph Johnson	Steph Johnson
9​	4259	Belinda Carter	Belinda Carter
10​	43637	Simone Hobbs	Simone Hobbs
11​	12498	not found	Sarah Fogg

B3=IFERROR(VLOOKUP(A3,$E$3:$F$6,2,0),"not found")
copied down

 

[L. Howard]

Hi there,

Try...

On sheet 2 =VLOOKUP(E1,Sheet2!$A$1:$B$9,2,0)

Assumes the lookup numbers are in column E, then pull down.

Howard

 

[CreativeRova]

Hi Guys,

Sorry i think i should of been clearer. I tried the formulas stated above to no success.

Sheet 1
3521	Joe Blog
2698	Susan Jones
451	Simon Hobb
7548	Amy Blur
6552	John Smith
12415	Jane Topper
32	Jarrod Long
4115	Tina Small
695	Matt Beard

<tbody>
</tbody>

Sheet 2
6599
2698	Susan Jones
1442
451	Simon Hobb
12415	Jane Topper

<tbody>
</tbody>

So on sheet 1 it shows number and name. On sheet 2 i want to check if the number that on sheet 2 appears on sheet 1 then show the corresponding name. (shown in green above)

 

[L. Howard]

Hi Guys,



So on sheet 1 it shows number and name. On sheet 2 i want to check if the number that on sheet 2 appears on sheet 1 then show the corresponding name. (shown in green above)

On sheet 1 column A is ALL the numbers.
On sheet 1 column B is ALL the names.

On sheet 2 the FEW numbers are in column A

On sheet 2 in column B =VLOOKUP(A1,Sheet1!$A$1:$B$9,2,0)

Then pull the formula down column B.

Howard

 

[Narendrareddy]

Try this

On sheet 2 in column B =IFERROR(VLOOKUP(A2,Sheet1!$A$1:$B$9,2,FALSE),"")

Then pull the formula down column B.

 

[FDibbins]

As indicated above, all you need to do is adjust the references to point to the other sheet

 

[CreativeRova]

thanks guys,

that worked perfectly.

 

[L. Howard]

To your off forum query:

Sheet Sponser:

First Last Donor-TFACTID
FN-1 LN-1
FN-2 LN-2
FN-3 LN-3
FN-4 LN-4
FN-5 LN-5

Where FN-1 is a first name & LN-1 is a last name in column A & B
Donor TFACTID is column C and the column you are seeking to fill in from Master sheet lookup (I may have the column name wrong, but it is C column)

In Donor-TFACTID column and pull down:
=IFERROR(VLOOKUP(A2&B2,Master!$A$2:$D$6,4,0),"")


Sheet Master:

Comb First Last Donor-TFACTID
FN-1LN-1 FN-1 LN-1 DT-1
FN-2LN-2 FN-2 LN-2 DT-2
FN-3LN-3 FN-3 LN-3 DT-3
FN-4LN-4 FN-4 LN-4 DT-4
FN-5LN-5 FN-5 LN-5 DT-5

Where In Comb column (column A as a "Helper Column") is the formula:

=B2&C2 and pull down

Me thinks I got it straight...

Give it a try with the ranges extended to suit your sheet.
Notice the $ $'s in the vlookup formula to secure the lookup range as you pull the formula down.

Howard