Thread: If return
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nicole Nicole is offline
external usenet poster
 
Posts: 53
Default If return

I need some help please...
If C2 = A:A than I want it to return the number that is in B:B next to the
match of C2

Quick report Number of Line Items Entry Number
3696821-7 1 7076693-1
3696901-7 1 9058675-6
7076693-1 68 8700137-1
8700008-4 2 8700136-3
8700009-2 1 8700135-5

So if 7076693-1 is found in quick report give me 68