Vlookup / Index,Match????

J

jambo72uk

Board Regular
Joined
May 8, 2012
Messages
77
Hi Guys,

Looking for an easy answer -hopefully,

A1 = R1000

B1 - B7 = 1-7

I want to be able to enter a formula into D1 to lookup A1 and return the 5th result in column B

Does this make sense?

Ta J
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Sort by date Sort by votes
Hi Gaz,

A1 = R1000 and the data in B1-B7 relates to this code (please bear in mind that A2-A7 is blank)

If i use the Vlookup function the return the data in B1 then it will return the date in B1 but i infact want the 2nd instance,

gaz_chops said:
No!
Click to expand...
 
Upvote 0
You really need to post a sample of your data.
So far you say you want to lookup R1000, where is it looking for a match?
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
Index/Match based on header names rather than columns
Replies
6
Views
595
Peter_SSs
Peter_SSs
B
  • Solved
Index, Match and Lookup Problem
Replies
1
Views
205
Fluff
Fluff
C
  • Solved
Index and match with result average
Replies
8
Views
723
dreid1011
dreid1011
O
  • Question
Vlookup() and Index(Match()) returning N/A, even though the lookup value exists in the range and is identical to that value within the range.
Replies
6
Views
1K
nemmi69
nemmi69
B
  • Solved
Index and Match Formula
Replies
6
Views
461
Alex Blakenburg
A

Forum statistics

Threads
1,214,951
Messages
6,122,446
Members
449,083
Latest member
Ava19

Share this page

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
Back
Top