Grabing cell from other sheet - row/column crossroad

[Victusify]

Ok, so I ran into another problem.

I know how to grab info I need from other sheet - but how can I do it when I have table? Like I have table in Sheet2:

A	B	C	D
B	AB	CB	DB
C	AC	BC	DC
D	AD	BD	CD

And lets say I want to grab cell from Row 1 and Column 3 (in this case, that would be cell with C) and place it in cell A1 in Sheet1. How should I do this?

[mikeTRON]

what are you wanting to use an the unique identifiers to grab the data (the actual column and row numbers, or do you have something else to go by)?

[Tony Valko]

Like this...

Data Range

	A	B	C	D	E	F	G
1	A	B	C	D		Row	1
2	B	AB	CB	DB		Column	3
3	C	AC	BC	DC		Result	C
4	D	AD	BD	CD
5	------	------	------	------	------	------	------

This formula entered in G3:

=INDEX(A1:D4,G1,G2)

However, this type of lookup application is typically based on the row and column headers.

For example:

Data Range

	A	B	C	D	E	F	G	H
1		Jan	Feb	Mar	Apr		Year	2014
2	2012	A	B	C	D		Month	Feb
3	2013	B	AB	CB	DB		Result	AC
4	2014	C	AC	BC	DC
5	2015	D	AD	BD	CD
6	------	------	------	------	------	------	------	------

We want to return the value that corresponds to 2014 and Feb. This formula entered in H3:

=VLOOKUP(H1,A1:E5,MATCH(H2,A1:E1,0),0)

[Victusify]

I used the INDEX one and it worked perfectly! Thanks so much

[Tony Valko]

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.