Thread: VLookup
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
rr rr is offline
external usenet poster
 
Posts: 20
Default VLookup

I pull the data from system in one page & gather logged verify data in second
page. I reconcile a summary & commented in the second page. The formula,
IF(ISERROR(VLOOKUP($C225,Log!$A$1:$D$200,3,0)),"", VLOOKUP($C225,Log!$A$1:$D$200,3,0)),
is used to pull the second page data to match with the first page system data
for record completeness. Therefore, the comment becomes very important.


"bigwheel" wrote:

Sorry, got posted to the wrong place. Your question needs a bit more
information. How is your data stored? What is the formula you are using?

"bigwheel" wrote:

I don't know if this is what you're looking for but try
http://www.psych.auckland.ac.nz/psyc...s/AppForms.htm

"rr" wrote:

I have used the VLookup to pull the data. The data shows up with my commend
and highlight. Somehow, it stops. VLookup only pulls the data. Help.