lookups

bluenose83

New Member
Joined
Aug 6, 2008
Messages
41
Hi Guys

Just after some advice.

Trying to create a lookup but unsure which one am meant to use.

In one sheet i have a figure in column E (example 44.93)

in another sheet i have four columns and in column D i have all figures going down including 44.93. In column B i have a letter which relates to that figure. What i need on my first sheet is the letter that relates to that figure. If that makes sence.

Any help would be great

Matt
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

jberwald

Board Regular
Joined
May 3, 2005
Messages
205
Important question is: Do your numbers ever repeat in column D with a different letter in column B. If so, this formula or any VLOOKUP won't work.

On a third sheet copy and paste your Column D in Column A; and your Column B in Column B. Sort in assending order of Column A.

On the sheet that you need the letter inserted that matches the number in column E, in the cell you want this letter, put this formula.


=vlookup(E1,Sheet3!$A$1:$B$100,2)
 

Akashwani

Well-known Member
Joined
Mar 14, 2009
Messages
2,911
Hi Matt,

Perhaps something like this on your first sheet....

=INDEX(Sheet2!$B$2:$B$7,MATCH(E2,Sheet2!$D$2:$D$7,0))

Change the sheet names and cell ranges to suit yours.

E2 is the cell on your first sheet where you have 44.93, change that cell reference to suit yours.

Good luck.

Ak
 

bluenose83

New Member
Joined
Aug 6, 2008
Messages
41
cheers for the info. both ways have worked exactly how i wanted so thanks very much.

i am slowly but surely getting to grips with excel ha
 

Watch MrExcel Video

Forum statistics

Threads
1,122,371
Messages
5,595,784
Members
414,020
Latest member
Meghdad

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top