I have over 500 different types of transactions and each one has its own code. These are listed on a worksheet. on a separate sheet i have report with dates, ttransactions code etc . is there a way of pulling the specific info from the list? ie if i type 157 intoe a3 then d3 shows the transaction, if i type in 445 d3 shows this transaction etc etc. important using 2007.
Does this make sense?
Vlookup will do that for you.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
You can accomplish this with vlookup or hlookup, depending on how your table is organized.
If your unique transaction code is on the left column, A2:A6
And your elements are on the top, B1:E1
Then try this:
Formula:
Please Login or Register to view this content.
This formula looks for the tag in A2, in the context of table A1:E6, and returning the value in the 3rd column over (to the right).
Replace VLOOKUP with HLOOKUP if your unique transaction numbers are at the top instead of the side.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks