hi,
I am trying to compare a sheet with horizontal data with a bigger sheet which has data horizontally and vertically . Is there a way to combine both Vlookup and Hlookup to provide if
data on sheet 1(pending list) is on sheet 2(pu log).Is there a way to simplify this otherwise?
any help would be appreciated?
Hi sonny.thind
I'd convert all the pu log data to look like the Pending List data. Excel works great with a table format, like the Pending List structure. The Pu log may be easier for you to read for now but converting it to a 3 column format would allow filtering and even pivot tables.
Let us know if that is a direction you'd like to go. If so, what date do you want on the sheet that has no date?
One test is worth a thousand opinions.
Click the * below to say thanks.
I agree with Marvin, your data structure is horrible and doesn't lend itself to doing anything really.
All your data should be organised on one worksheet with columns Date ¦ Store ¦ Invoice.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Re: combine Vlookup with Hlookup
LOL thanks guys!,Apparently that's what I have ,to play with. This was an even worse file when I got it but I managed to clear the formats to make it more readable. this is a security log and is done by temp staff who have no clear idea about excel.
I just need to compare the Pending List to the PU log sheet to verify if the store and Invoice together show up on the PU log sheet. This would tell me if those pending invoices actually went through the security log and on which date. ignore the date on the pending list that is the date the invoice was created which is not relevant. I have combined all the information into one sheet. Not sure if that would help.
thanks again for the help...
HI,
I'd open my attached "Pendind List Find" and search for each of the 4th column stings in you new file.
One test is worth a thousand opinions.
So do I need to use "ctrl+F" and search for every invoice on the log sheet- or can this be done with a Code?. I was thinking of a more easier way to get this info from such vast data.
If both worksheets were in the same workbook then code would be much easier. You might even do it with a formula instead of code.
One test is worth a thousand opinions.
So what formula do I use ? or if there is a code I can use?
I can still combine them into one sheet. see attached. Lookup doesn't help would Match or Index help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks