Excel Data calling

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, I'm new here but am hoping you can help me please! :)

in one sheet I have a list of days and payments that corospond to the days

the other sheet is "On call Payments" I need to be able to enter a day then
have the payment from the first sheet appear in the payment coloumn on the
"On call Payments" ??

Hopw you understand and can help

Thanks

** Confused**
Kaya
 
Ok, assuming your data is on sheet 1, with column a holding the date an
column B holding the payment

on sheet 2 say you enter the date in B2

the formula you need should then be

=vlookup(b2,Sheet1!A1:B10,2
 
I would guess that the OP may want an exact match on the date.

If yes, then this version of Alex's formula may work ok:
=vlookup(b2,Sheet1!A1:B10,2,False)

And if the OP is not familiar with =vlookup(), Debra Dalgleish has nice
instructions at:
http://www.contextures.com/xlFunctions02.html
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Date and amount of last payment 3
identifying the next working day after weekends and/or holidays 2
Calculating Days Late 1
Excell formula 1
SUMPRODUCT 2
Changing dates automatically with the computer date 2
Excel 2007 Pivot Table Question 2

Back
Top