lookups

[bluenose83]

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

 

[jberwald]

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]

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]

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