combine Vlookup with Hlookup

[sonny.thind]

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?

[MarvinP]

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?

[Domski]

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

[sonny.thind]

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...

[MarvinP]

HI,
I'd open my attached "Pendind List Find" and search for each of the 4th column stings in you new file.

[sonny.thind]

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.

[MarvinP]

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.

[sonny.thind]

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?