Vlookup but with a twisy required solution

[ranjanagarwal]

Data on sheet One that needs to be copied to sheet two without using copy paste.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Exp[/TD]
[TD]July15[/TD]
[/TR]
[TR]
[TD]

Books
​

[/TD]
[TD]9000[/TD]
[/TR]
[TR]
[TD]

Goods
​

[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]

Taxi
​

[/TD]
[TD]8000[/TD]
[/TR]
[TR]
[TD]

Milk
​

[/TD]
[TD]1000[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Revenue[/TD]
[TD]July15[/TD]
[/TR]
[TR]
[TD]

Books
​

[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]

Goods
​

[/TD]
[TD]9000[/TD]
[/TR]
[TR]
[TD]

Taxi
​

[/TD]
[TD]12000[/TD]
[/TR]
[TR]
[TD]

Milk
​

[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD]Exp[/TD]
[TD]July15[/TD]
[/TR]
[TR]
[TD]

Books
​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

Goods
​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

Taxi
​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

Milk
​

[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD]Revenue[/TD]
[TD]July15[/TD]
[/TR]
[TR]
[TD]

Books
​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

Goods
​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

Taxi
​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

Milk
​

[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Is there a way other than copy and paste the data to get the data from Sheet 1 to Sheet 2?

I tried this but did not work

=IF((CONCATENATE(B193,B194=CONCATENATE('[xyz.xlsx]Expense YTD'!$A$30,'[xyz.xlsx]Expense YTD'!$A$31))),(VLOOKUP(B194,'[xyz.xlsx]Expense YTD'!$A$30:$N$46,3,FALSE)),"")

What I was trying to is to concatenate Exp and Book and look for the same concatenation in Sheet 2 and return a value that matches the vlookup criteria.


Thanks in advance for looking into this problem.

 

[cbatrody]

Hi,

Are these two (headers and the items under it) different columns or one column?