Lookup Help

[GoBlue589]

Hello,

I have been working for some time on figuring out how to do a lookup.

What I am looking to do is the ability to plug a 4 digit number in cell I7 to I9 and for it to reference the range of numbers between B7:B31 and C7:C31 and for the date (in cells A7:A31) to be put into cell J7:J9.


I know I will most likely have to change the columns in B & C to make it a range over numbers.


I can explain a litle bit more if this is confusing.


Thank you in advance!

 

[GoBlue589]

Hello,

I have been working for some time on figuring out how to do a lookup.

What I am looking to do is the ability to plug a 4 digit number in cell I7 to I9 and for it to reference the range of numbers between B7:B31 and C7:C31 and for the date (in cells A7:A31) to be put into cell J7:J9.


I know I will most likely have to change the columns in B & C to make it a range over numbers.


I can explain a litle bit more if this is confusing.


Thank you in advance!

 

[GoBlue589]

Offline Dates.xlsx
	A	B	C	D			G	H	I	J
6	MAY	First Vin Offline	Last Vin Offline						Vin	Date
7	3-May	6775	6790						6784
8	4-May	6791	6806						6871
9	5-May	6807	6822						7079
10	6-May	6823	6838
11	7-May	6839	6854
12
13	10-May	6855	6870
14	11-May	6871	6886
15	12-May	6887	6902
16	13-May	6903	6918
17	14-May	6919	6934
18	1
19	17-May	6935	6950
20	18-May	6951	6966
21	19-May	6967	6982
22	20-May	6983	6998
23	21-May	6999	7014
24
25	24-May	7015	7030
26	25-May	7031	7046
27	26-May	7047	7062
28	27-May	7063	7078
29	28-May	7079	7094
30
31	31-May	7095	7110
Sheet1

Cell Formulas
Range	Formula
B7	B7	=C4+1
C7	C7	=C4+F7
B26:B29,B20:B23,B14:B17,B8:B11	B8	=C7+1
C26:C29,C20:C23,C14:C17,C8:C11	C8	=C7+F7
B13,B31,B25,B19	B13	=C11+1
C13,C31,C25,C19	C13	=C11+F11

Here is a mini sheet

 

[kweaver]

Isn't what you want an index/match?

=IFERROR(INDEX(A7:A28,MATCH(I7,B7:B28,0)),"")

 

[Fluff]

Or maybe

=INDEX($A$7:$A$31,MATCH(I7,$B$7:$B$31,1))

 

[GoBlue589]

Or maybe

=INDEX($A$7:$A$31,MATCH(I7,$B$7:$B$31,1))[/CODE
[/QUOTE]

THANK YOU! 

Finally was able to get it figured out.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[GoBlue589]

Glad we could help & thanks for the feedback.

One more quick question... When I copy and paste from our inventory system, it has DE900. Is there any way I could get it so that whenever I copy and paste, it will automatically delete the DE900?

 

[Fluff]

Not without a macro.