Search:

Type: Posts; User: kywenyi; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    6
    Views
    436

    Re: Hyperlink & Vlookup formula

    i think 2003?
  2. Replies
    6
    Views
    436

    Re: Hyperlink & Vlookup formula

    i tried but can't. it shows NA.
  3. Replies
    6
    Views
    436

    Re: Hyperlink & Vlookup formula

    i cannot do that. i have a full list of data and they are not in fixed row on sheet 2. previously my colleague use the normal hyperlink but i realise whenever i add a data in sheet 2, my hyperlink...
  4. Replies
    6
    Views
    436

    Hyperlink & Vlookup formula

    hi, i have 1 workbook with 2 tabs - on Sheet 1 i need to hyperlink the column COLOR to Sheet 2 with vlookup function.

    i've tried this but doesn't work. =HYPERLINK(VLOOKUP(B2,'SHEET 2'!A1:B3,2,0) ...
  5. Replies
    7
    Views
    414

    Re: fixed a hyperlink

    I already made myself clear. I want to hyperlink from sheet A to a specific cell in Sheet B. and when adding row to Sheet B, it will still be hyperlinked to the correct data. and yes, i want to click...
  6. Replies
    7
    Views
    414

    Re: fixed a hyperlink

    Hi sorry, am new to this forum.

    Okay..

    Sheet A - Jane (A1:A10) & (A30:A32)
    Sheet B - Jane (A4)
    Sheet A - Mark (A20:A15)
    Sheet B - Mark (A17)

    i can easily hyperlink the above but...
  7. Replies
    4
    Views
    358

    Re: I need formula to auto detect errors

    i'll try to explain again. maybe in another way. let me think.. hmmm..

    1) how do I extract data from 1 workbook to another workbook? i have 8 workbook and was thinking to extract all data of a...
  8. Replies
    7
    Views
    414

    Re: fixed a hyperlink

    I will have a data "Jane" in tab A cell A1. when click on "Jane", it will hyperline to tab B cell A50. the reason being because we have more details for "Jane" and when click on "Jane" it will...
  9. Replies
    7
    Views
    414

    fixed a hyperlink

    hi, i need to hyperlink my data from 1 tab to another tab in the same workbook. but i often need to insert data and my hyperlink will all run. is there anyway to fix a hyperlink to that particular...
  10. Replies
    4
    Views
    358

    Re: I need formula to auto detect errors

    SET A SET B
    ITEM CODE QTY ITEM CODE QTY RESULT
    Banana 5 Banana 4 Wrong
    Apple 8 Apple 8 Correct
    Grapes 3 Mangosteen 1 Correct
    Mangosteen 1 Peach 7 Missing
    Durian
    Lemon 10 ...
  11. Replies
    4
    Views
    358

    I need formula to auto detect errors

    Hi, i will insert 2 sets of data to insert in excel. i need formula to auto check which are the data that have error. like data 1 is the correct data, data 2 is the data that might have error. so...
Results 1 to 11 of 11