Hi All,
I am stucked on the formular: I have data sitting in Sheet1. And in Sheet2 range C2:K4, I am trying to look up the value from Sheet1, eg, the value in C2 should be 200, and D2 should be 201..... Can anyone help me with writing a formular?
A sample file is attached.
Any help would be greatly appreciated!
Bookmarks