Results 1 to 4 of 4

Match 2 cells to produce a third value

Threaded View

  1. #1
    Registered User
    Join Date
    09-06-2009
    Location
    Sussex, England
    MS-Off Ver
    Excel 2003 / Pocket Excel
    Posts
    6

    Question Match 2 cells to produce a third value

    Hi,

    I have 2 sheets of data one for data the second for input and calculations.


    SHEET 1 (Data)
    HEADINGS - FROM / NUMBER
    A / 81
    C / 99
    E / 01

    SHEET 2 (Input & Calculations)HEADINGS - FROM / TO / FROM val / TO val

    I want to be able to stick "A" in Col1 (FROM) and the number 81 to automatically appear in Col3 (FROM Val)


    I am unabel to use LOOKUP as my Pocket PC doesen't recognise it.. VLOOKUP and HLOOKUP are ok though, I just can't seem to get them to work for me

    L.
    Last edited by Lee.shop; 09-11-2009 at 04:54 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1